﻿CREATE TABLE [dbo].[06_synthetische_Buchungen] (
    [Id]               INT            IDENTITY (1, 1) NOT NULL,
    [Buchungstag]      VARCHAR (15)   NOT NULL,
    [Verwendungszweck] VARCHAR (255)  NULL,
    [Betrag]           DECIMAL (8, 2) NOT NULL,
    [Wertdatum]        VARCHAR (15)   NULL,
    [CreatedOn]        DATETIME2 (0)  NULL,
    [ZweckMatchID]     INT            NULL,
    [ZweckID_manuell]  INT            NULL,
    CONSTRAINT [PK_06] PRIMARY KEY CLUSTERED ([Id] ASC)
);

